SupplierPricePromotionZone

Entity Definition

Logical Name : SupplierPricePromotionZone
Physical Name : CO_ZN_SPR_PRC_PRM

An association between the RETAIL STORE and a SUPPLIER used to describe the price and promotional geographical zone a store has been assigned to by a supplier.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SupplierID (FK)(PK) A unique system assigned identifier for the Supplier. ID_SPR Identity integer Supplier(PA_SPR)
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer RetailStore(PA_STR_RTL)
PriceZoneCode A code to signify the pricing policy for a specific geographic zone LU_ZN_PR Code4 char(4)
PromotionalZoneCode A code to signify the pricing promotion policy for a specific geographic zone LU_ZN_PRM Code4 char(4)
FreightZoneCode A code to signify the freight charges to retail stores within a specific geographic zone LU_ZN_SPR_FRGT Code4 char(4)

Relationships

Parent Entity Verb Phrase Child Entity
Supplier establishes SupplierPricePromotionZone
RetailStore resides in SupplierPricePromotionZone

Logical Views containing SupplierPricePromotionZone

Logical View
Logical 01500 - Item Supplier View